    USE [DB]
    GO

    SET ANSI_NULLS ON
    GO

    SET QUOTED_IDENTIFIER ON
    GO


    ALTER Function [dbo].[FunctionC] (@name varchar(50),@email varchar(50))

    returns varchar(100)

    as

    Begin

    Return(left(@name,4) + @email)

    End

    GO